﻿SET QUOTED_IDENTIFIER ON
GO
SET ARITHABORT ON
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET CONCAT_NULL_YIELDS_NULL ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_PADDING ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE [dbo].[bhp_TempCreateMimeTypes] 
AS
BEGIN
	
	DECLARE
		@GroupId	INT

	EXEC [dbo].[n_TableAdd] 'SYS_MIMETYPES', 900900
		SELECT @GroupId = id FROM n_Tree t WHERE t.name = 'SYS_MIMETYPES'

	EXEC [dbo].[n_ColFAdd] @rel = @GroupId, @name = N'file_extension', @typ = 2, @siz1 = 10, @siz2 = 1, @user = 900900
	EXEC [dbo].[n_ColFAdd] @rel = @GroupId, @name = N'type_name', @typ = 2, @siz1 = 100, @siz2 = 1, @user = 900900
	EXEC [dbo].[n_ColFAdd] @rel = @GroupId, @name = N'mime_media_type', @typ = 2, @siz1 = 100, @siz2 = 1, @user = 900900

END
GO
EXEC [dbo].[bhp_TempCreateMimeTypes]
GO
DROP PROCEDURE [dbo].[bhp_TempCreateMimeTypes]
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio 3GPP files', 'Audio 3GPP files', '.3gp', 'audio/3gpp');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio AMR files', 'Audio AMR files', '.amr', 'audio/amr');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio AMR (wideband) files', 'Audio AMR (wideband) files', '.awb', 'audio/amr-wb');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio MIDI files', 'Audio MIDI files', '.mid', 'audio/midi');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio MIDI files', 'Audio MIDI files', '.midi', 'audio/midi');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio MP3 files', 'Audio MP3 files', '.mp3', 'audio/mpeg');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio MP4 files', 'Audio MP4 files', '.mp4', 'audio/mp4');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Audio WAV files', 'Audio WAV files', '.wav', 'audio/wav');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'HTML files', 'HTML files', '.htm', 'text/html');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'HTML files', 'HTML files', '.html', 'text/html');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'xHTML files', 'HTML files', '.html', 'text/xhtml+xml');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image BMP files', 'Image BMP files', '.bmp', 'image/bmp');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image GIF files', 'Image GIF files', '.gif', 'image/gif');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image JPEG files', 'Image JPEG files', '.jpg', 'image/jpeg');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image JPEG files', 'Image JPEG files', '.jpeg', 'image/jpeg');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image PNG files', 'Image PNG files', '.png', 'image/png');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image TIFF files', 'Image TIFF files', '.tif', 'image/tiff');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Image TIFF files', 'Image TIFF files', '.tiff', 'image/tiff');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Plain text files', 'Plain text files', '.txt', 'text/plain');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Video 3GPP files', 'Video 3GPP files', '.3gp', 'video/3gpp');
GO
INSERT INTO SYS_MIMETYPES (del, ctime, identyfikator, [type_name], file_extension, mime_media_type) VALUES (0, GETDATE(), 'Video MP4 files', 'Video MP4 files', '.mp4', 'video/mp4');